{\rtf1\adeflang1025\ansi\ansicpg1252\uc1\adeff0\deff0\stshfdbch0\stshfloch0\stshfhich0\stshfbi0\deflang1033\deflangfe1033{\fonttbl{\f0\froman\fcharset0\fprq2{\*\panose 02020603050405020304}Times New Roman;}{\f2\fmodern\fcharset0\fprq1{\*\panose 02070309020205020404}Courier New;}
{\f3\froman\fcharset2\fprq2{\*\panose 05050102010706020507}Symbol;}{\f10\fnil\fcharset2\fprq2{\*\panose 05000000000000000000}Wingdings;}{\f37\froman\fcharset238\fprq2 Times New Roman CE;}{\f38\froman\fcharset204\fprq2 Times New Roman Cyr;}
{\f40\froman\fcharset161\fprq2 Times New Roman Greek;}{\f41\froman\fcharset162\fprq2 Times New Roman Tur;}{\f42\fbidi \froman\fcharset177\fprq2 Times New Roman (Hebrew);}{\f43\fbidi \froman\fcharset178\fprq2 Times New Roman (Arabic);}
{\f44\froman\fcharset186\fprq2 Times New Roman Baltic;}{\f45\froman\fcharset163\fprq2 Times New Roman (Vietnamese);}{\f57\fmodern\fcharset238\fprq1 Courier New CE;}{\f58\fmodern\fcharset204\fprq1 Courier New Cyr;}
{\f60\fmodern\fcharset161\fprq1 Courier New Greek;}{\f61\fmodern\fcharset162\fprq1 Courier New Tur;}{\f62\fbidi \fmodern\fcharset177\fprq1 Courier New (Hebrew);}{\f63\fbidi \fmodern\fcharset178\fprq1 Courier New (Arabic);}
{\f64\fmodern\fcharset186\fprq1 Courier New Baltic;}{\f65\fmodern\fcharset163\fprq1 Courier New (Vietnamese);}}{\colortbl;\red0\green0\blue0;\red0\green0\blue255;\red0\green255\blue255;\red0\green255\blue0;\red255\green0\blue255;\red255\green0\blue0;
\red255\green255\blue0;\red255\green255\blue255;\red0\green0\blue128;\red0\green128\blue128;\red0\green128\blue0;\red128\green0\blue128;\red128\green0\blue0;\red128\green128\blue0;\red128\green128\blue128;\red192\green192\blue192;}{\stylesheet{
\ql \li0\ri0\widctlpar\wrapdefault\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af0\afs24\alang1025 \ltrch\fcs0 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 \snext0 \styrsid10508937 Normal;}{\*\cs10 \additive \ssemihidden 
Default Paragraph Font;}{\*\ts11\tsrowd\trftsWidthB3\trpaddl108\trpaddr108\trpaddfl3\trpaddft3\trpaddfb3\trpaddfr3\trcbpat1\trcfpat1\tblind0\tblindtype3\tscellwidthfts0\tsvertalt\tsbrdrt\tsbrdrl\tsbrdrb\tsbrdrr\tsbrdrdgl\tsbrdrdgr\tsbrdrh\tsbrdrv 
\ql \li0\ri0\widctlpar\wrapdefault\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af0\afs20 \ltrch\fcs0 \fs20\lang1024\langfe1024\cgrid\langnp1024\langfenp1024 \snext11 \ssemihidden Normal Table;}}
{\*\latentstyles\lsdstimax156\lsdlockeddef0}{\*\listtable{\list\listtemplateid-124904324\listhybrid{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat0\levelspace0\levelindent0{\leveltext\leveltemplateid-1963715922
\'01-;}{\levelnumbers;}\loch\af0\hich\af0\dbch\af0\fbias0 \fi-360\li720\jclisttab\tx720\lin720 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\lvltentative\levelspace0\levelindent0{\leveltext\leveltemplateid67698691
\'01o;}{\levelnumbers;}\f2\fbias0 \fi-360\li1440\jclisttab\tx1440\lin1440 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\lvltentative\levelspace0\levelindent0{\leveltext\leveltemplateid67698693
\'01\u-3929 ?;}{\levelnumbers;}\f10\fbias0 \fi-360\li2160\jclisttab\tx2160\lin2160 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\lvltentative\levelspace0\levelindent0{\leveltext\leveltemplateid67698689
\'01\u-3913 ?;}{\levelnumbers;}\f3\fbias0 \fi-360\li2880\jclisttab\tx2880\lin2880 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\lvltentative\levelspace0\levelindent0{\leveltext\leveltemplateid67698691
\'01o;}{\levelnumbers;}\f2\fbias0 \fi-360\li3600\jclisttab\tx3600\lin3600 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\lvltentative\levelspace0\levelindent0{\leveltext\leveltemplateid67698693
\'01\u-3929 ?;}{\levelnumbers;}\f10\fbias0 \fi-360\li4320\jclisttab\tx4320\lin4320 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\lvltentative\levelspace0\levelindent0{\leveltext\leveltemplateid67698689
\'01\u-3913 ?;}{\levelnumbers;}\f3\fbias0 \fi-360\li5040\jclisttab\tx5040\lin5040 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\lvltentative\levelspace0\levelindent0{\leveltext\leveltemplateid67698691
\'01o;}{\levelnumbers;}\f2\fbias0 \fi-360\li5760\jclisttab\tx5760\lin5760 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\lvltentative\levelspace0\levelindent0{\leveltext\leveltemplateid67698693
\'01\u-3929 ?;}{\levelnumbers;}\f10\fbias0 \fi-360\li6480\jclisttab\tx6480\lin6480 }{\listname ;}\listid1894392599}}{\*\listoverridetable{\listoverride\listid1894392599\listoverridecount0\ls1}}{\*\rsidtbl \rsid6967018\rsid10508937\rsid16398019}
{\*\generator Microsoft Word 11.0.0000;}{\info{\title What is mygroupmanager}{\author Guillaume}{\operator Guillaume}{\creatim\yr2008\mo10\dy12\hr19\min54}{\revtim\yr2008\mo10\dy12\hr19\min54}{\version2}{\edmins1}{\nofpages1}{\nofwords255}{\nofchars1456}
{\nofcharsws1708}{\vern24613}{\*\password 00000000}}{\*\xmlnstbl {\xmlns1 http://schemas.microsoft.com/office/word/2003/wordml}}\paperw12240\paperh15840\margl1800\margr1800\margt1440\margb1440\gutter0\ltrsect 
\widowctrl\ftnbj\aenddoc\donotembedsysfont1\donotembedlingdata0\grfdocevents0\validatexml1\showplaceholdtext0\ignoremixedcontent0\saveinvalidxml0\showxmlerrors1\noxlattoyen\expshrtn\noultrlspc\dntblnsbdb\nospaceforul\formshade\horzdoc\dgmargin\dghspace180
\dgvspace180\dghorigin1800\dgvorigin1440\dghshow1\dgvshow1
\jexpand\viewkind1\viewscale100\pgbrdrhead\pgbrdrfoot\splytwnine\ftnlytwnine\htmautsp\nolnhtadjtbl\useltbaln\alntblind\lytcalctblwd\lyttblrtgr\lnbrkrule\nobrkwrptbl\snaptogridincell\allowfieldendsel\wrppunct
\asianbrkrule\rsidroot10508937\newtblstyruls\nogrowautofit \fet0{\*\wgrffmtfilter 013f}\ilfomacatclnup0\ltrpar \sectd \ltrsect\linex0\headery708\footery708\colsx708\endnhere\sectlinegrid360\sectdefaultcl\sftnbj {\*\pnseclvl1
\pnucrm\pnstart1\pnindent720\pnhang {\pntxta .}}{\*\pnseclvl2\pnucltr\pnstart1\pnindent720\pnhang {\pntxta .}}{\*\pnseclvl3\pndec\pnstart1\pnindent720\pnhang {\pntxta .}}{\*\pnseclvl4\pnlcltr\pnstart1\pnindent720\pnhang {\pntxta )}}{\*\pnseclvl5
\pndec\pnstart1\pnindent720\pnhang {\pntxtb (}{\pntxta )}}{\*\pnseclvl6\pnlcltr\pnstart1\pnindent720\pnhang {\pntxtb (}{\pntxta )}}{\*\pnseclvl7\pnlcrm\pnstart1\pnindent720\pnhang {\pntxtb (}{\pntxta )}}{\*\pnseclvl8\pnlcltr\pnstart1\pnindent720\pnhang 
{\pntxtb (}{\pntxta )}}{\*\pnseclvl9\pnlcrm\pnstart1\pnindent720\pnhang {\pntxtb (}{\pntxta )}}\pard\plain \ltrpar\ql \li0\ri0\widctlpar\wrapdefault\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid10508937 \rtlch\fcs1 \af0\afs24\alang1025 
\ltrch\fcs0 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\rtlch\fcs1 \af0 \ltrch\fcs0 \b\ul\insrsid6967018 What is MyGroupM}{\rtlch\fcs1 \af0 \ltrch\fcs0 \b\ul\insrsid10508937\charrsid6967018 anager
\par }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10508937\charrsid3238048 
\par }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10508937\charrsid10557175 My}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid6967018 GroupM}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10508937\charrsid10557175 anager is a dedicated tool }{\rtlch\fcs1 \af0 \ltrch\fcs0 
\insrsid6967018 for MySQL}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10508937  databases administrator, which add a simple group management feature to the traditional }{\rtlch\fcs1 \af0 \ltrch\fcs0 \i\insrsid6967018\charrsid6967018 MySQL Administrator}{
\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10508937  application.
\par 
\par }{\rtlch\fcs1 \af0 \ltrch\fcs0 \b\ul\insrsid10508937\charrsid6967018 How it works
\par }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10508937 
\par First, you create a "group" account, otherwise said,}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid6967018  a user template, in }{\rtlch\fcs1 \af0 \ltrch\fcs0 \i\insrsid6967018\charrsid6967018 MySQL A}{\rtlch\fcs1 \af0 \ltrch\fcs0 
\i\insrsid10508937\charrsid6967018 dministrator}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10508937 
.  Once created, you set it as "group" by simply adding the group name into the description field, following this naming convention : group_groupname, where groupname is the name of the group you want to create.
\par 
\par }{\rtlch\fcs1 \af0 \ltrch\fcs0 \b\ul\insrsid10508937\charrsid6967018 Conf}{\rtlch\fcs1 \af0 \ltrch\fcs0 \b\ul\insrsid6967018\charrsid6967018 igure MyGroupManager}{\rtlch\fcs1 \af0 \ltrch\fcs0 \b\ul\insrsid10508937\charrsid6967018 
\par }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10508937 
\par In options/settings, give the connection string to be used : typically, it will be similar to this one : }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10508937\charrsid10557175 driver=\{mysql odbc 3.51 driver\}; server=10.0.0.1;}{\rtlch\fcs1 \af0 \ltrch\fcs0 
\insrsid10508937  port=3306}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10508937\charrsid10557175 ;database=mysql; uid=root; pwd=}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10508937 placeyourpasswordhere}{\rtlch\fcs1 \af0 \ltrch\fcs0 
\insrsid10508937\charrsid10557175 ; option=3;
\par }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10508937 
\par Restart the program, and voil\'e0 !
\par 
\par }{\rtlch\fcs1 \af0 \ltrch\fcs0 \b\ul\insrsid10508937\charrsid6967018 How to add, or remove users from groups, and synchronize the database
\par }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10508937 
\par You have three panes : groups, members and users.  First select the group you want to edit, then double click on the users you want to promote as members 
of the current group.  The same way apply to remove a member of the group. Simply double click on a member of the current group to demote this member to a single user.
\par 
\par Limitations
\par 
\par By design, a user can only be member of a single group.  Putting a user in
 more than one group is not possible, thus, and only the last "membership" will be kept.  Let suppose that you have a user mike and that you put mike in the group "normal", then in another group "admins", only the membership to the group "admins" will be 
kept.
\par 
\par Practical : what does the synchronization
\par 
\par The following tables are updated by the program
\par 
\par {\listtext\pard\plain\ltrpar \rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10508937 \hich\af0\dbch\af0\loch\f0 -\tab}}\pard \ltrpar\ql \fi-360\li720\ri0\widctlpar
\jclisttab\tx720\wrapdefault\aspalpha\aspnum\faauto\ls1\adjustright\rin0\lin720\itap0\pararsid10508937 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10508937 User (only fields ending with "_priv"
\par {\listtext\pard\plain\ltrpar \rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10508937\charrsid12000457 \hich\af0\dbch\af0\loch\f0 -\tab}}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10508937\charrsid12000457 Columns_priv}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10508937 

\par {\listtext\pard\plain\ltrpar \rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10508937\charrsid12000457 \hich\af0\dbch\af0\loch\f0 -\tab}}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10508937\charrsid12000457 Procs_priv}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10508937 
\par {\listtext\pard\plain\ltrpar \rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10508937\charrsid12000457 \hich\af0\dbch\af0\loch\f0 -\tab}}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10508937\charrsid12000457 Tables_priv}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10508937 

\par {\listtext\pard\plain\ltrpar \rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10508937 \hich\af0\dbch\af0\loch\f0 -\tab}}\pard \ltrpar\ql \fi-360\li720\ri0\widctlpar\jclisttab\tx720\wrapdefault\aspalpha\aspnum\faauto\ls1\adjustright\rin0\lin720\itap0 {\rtlch\fcs1 
\af0 \ltrch\fcs0 \insrsid10508937 Db
\par }}